Computer Science for IGCSE & O level - Databases (Section 6 - No. 42)

What is a foreign key used for?

To uniquely identify records in a table.

To establish a relationship between two tables.

To ensure data integrity.

To speed up data retrieval.

A foreign key establishes a connection between tables and ensures data consistency by referencing the primary key of another table.